CREATE VIEW [dbo].[vCsRegFunctions] AS SELECT
    Order_Lines.DESCRIPTION AS Description,
    Order_Lines.EXTENDED_AMOUNT AS ExtendedAmount,
    Order_Lines.INCOME_ACCOUNT AS IncomeAccount,
    Order_Lines.NOTE AS Note,
    Order_Lines.PRODUCT_CODE AS ProductCode,
    Order_Lines.QUANTITY_ORDERED AS QuantityOrdered,
    Order_Lines.QUANTITY_SHIPPED AS RegisteredQuantity,
    Order_Lines.TAX_1 AS Tax1,
    Order_Lines.TAX_RATE AS TaxRate,
    Order_Lines.UNIT_PRICE AS UnitPrice,
    Orders.BT_ID AS BillToId,
    Orders.COMPANY AS Company,
    Orders.COMPANY_SORT AS CompanySort,
    Orders.FULL_NAME AS FullName,
    Orders.INVOICE_DATE AS InvoiceDate,
    Orders.INVOICE_NUMBER AS InvoiceNumber,
    Orders.INVOICE_REFERENCE_NUM AS InvoiceReferenceNumber,
    Orders.IS_FR_ORDER AS IsFrOrder,
    Orders.ORDER_DATE AS OrderDate,
    Orders.ORDER_NUMBER AS OrderNumber,
    Orders.ST_ID AS ShipToId,
    Orders.STATUS AS Status
FROM Orders
    INNER JOIN Order_Lines
        ON Orders.ORDER_NUMBER = Order_Lines.ORDER_NUMBER
WHERE Orders.ORDER_TYPE_CODE = 'MEETING'

GO